package com.zj.healthmanage.mapper;

import com.zj.healthmanage.pojo.Orderlist;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;
import java.util.Map;

public interface OrderlistMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Orderlist record);

    int insertSelective(Orderlist record);

    Orderlist selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Orderlist record);

    int updateByPrimaryKey(Orderlist record);

    List<Map> queryOrderListByPage(@Param("startDate") String startDate,
                                       @Param("endDate") String endDate,
                                       @Param("orderType") String orderType,
                                       @Param("orderStatus") String orderStatus,
                                       @Param("telephone") String orderNumber);

    List<Orderlist> queryOrderListByMemberId(@Param("member_id") Integer memberId,
                                      @Param("orderDate") Date date,
                                      @Param("setmeal_id") Integer setmealId);

    Orderlist queryOrderListById(Integer id);

    Integer queryOrderCountByDate(String date);

    Integer queryOrderCountAfterDate(String date);

    Integer queryVisitsCountByDate(String date);

    Integer queryVisitsCountAfterDate(String date);

    List<Map> queryHotSetmeal();

}